CREATE PROCEDURE PDA_UpdateQtyhavaleh
    @Id VARCHAR(MAX),
    @Qty VARCHAR(MAX)
AS
UPDATE TmpHavaleh
SET K_Qty1 = @Qty
WHERE Id = @Id;

-------- Update Over Under -----------

DECLARE @Id_Havahel VARCHAR(MAX);
DECLARE @AutoId VARCHAR(MAX);
SELECT TOP 1
       @Id_Havahel = Id_Havaleh,
       @AutoId = AutoId
FROM dbo.TmpHavaleh
WHERE Id = @Id;

EXEC dbo.PDA_CalcOverUnderRow @Id = @Id_Havahel,
                              @AutoId = @AutoId,
                              @isUpdate = 1;


